2013-05-29 - 5996.200 - Rel Notes - Changes to SA170 #BIReleases2013
Release Notes:
5996.200 - Changes to SA170
Admin Info
Purpose
|
Changes to SA170
|
Release No
|
001
|
Submitted
|
05-29-2013
|
Submitted by
|
Naga Brahmam R
|
Source/Destination Systems
|
Remote Machine to IT -> BMS -> Quality in BOBI 4.0 Dev
|
Release Sent To
|
Steven Hayes
|
Object(s) Created By
|
Naga Brahmam R
|
Object(s) Tested By
|
Uday Kumar P
|
Report Name
SA170 - Shipped + Open by Region
BEx Query
ZMP_OPASA_Q014
NEC Crystal Reports Standards Check
1. SA170 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA170 NEC CR checklist has been sent to NEC and also attached here for reference:
Summary Level Check
Test Conducted
Report Header
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
31,542,308
|
31,542,308.09
|
Pass
|
2
|
Open
|
28,887
|
28,886.71
|
Pass
|
3
|
Last Year
|
17,923,109
|
17,923,108.58
|
Pass
|
4
|
Total
|
31,571,195
|
31,571,194.80
|
Pass
|
Dynamic Group 1:
Test Conducted
Dynamic Grouping Parameter(1) and Group Name: Region > Country > Sales Rep > Customer
Secondary Level Check
Test Conducted
Group: EMEA
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
6,316,258
|
6,316,257.74
|
Pass
|
2
|
Open
|
7,893
|
7,893.39
|
Pass
|
3
|
Last Year
|
6,355,149
|
6,355,148.53
|
Pass
|
4
|
Total
|
6,324,151
|
6,324,151.13
|
Pass
|
Third Level Check
Test Conducted
Group: Emerging Markets > Chile
Period - May
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
23,348
|
23,347.52
|
Pass
|
2
|
Open
|
35,240
|
35,239.72
|
Pass
|
3
|
Last Year
|
14,615
|
14,614.80
|
Pass
|
4
|
Total
|
58,587
|
58,587.24
|
Pass
|
Fourth Level Check
Test Conducted
Group: North America > Canada> Action sports accoun
Period - April
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
3,438
|
3,438.00
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Last Year
|
14,705
|
14,705.00
|
Pass
|
4
|
Total
|
3,438
|
3,438.00
|
Pass
|
Fifth Level Check
Test Conducted
Group: EMEA > Andorra > Stephane Dauger > OLYMPIA
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
8,458
|
8,458.23
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Last Year
|
3,614
|
3,614.36
|
Pass
|
4
|
Total
|
8,458
|
8,458.23
|
Pass
|
Dynamic Group 2:
Test Conducted
Dynamic Grouping Parameter(1) and Group Name: Region > Sales Manager > Sales Rep > Customer
Secondary Level Check
Test Conducted
Group: Emerging Sales
Period - April
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
1,934,606
|
1,934,605.52
|
Pass
|
2
|
Open
|
54,621
|
54,621.15
|
Pass
|
3
|
Last Year
|
1,957,776
|
1,957,775.87
|
Pass
|
4
|
Total
|
1,989,227
|
1,989,226.67
|
Pass
|
Third Level Check
Test Conducted
Group:North America > Bill Adams
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
16,843,138
|
16,843,138.41
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Last Year
|
23,169,127
|
23,169,126.99
|
Pass
|
4
|
Total
|
16,843,138
|
16,843,138.41
|
Pass
|
Fourth Level Check
Test Conducted
Group: EMEA > John Casey > Gerard Van Der Beek
Period - May
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
141,959
|
141,959.15
|
Pass
|
2
|
Open
|
20,446
|
20,445.59
|
Pass
|
3
|
Last Year
|
144,248
|
144,247.99
|
Pass
|
4
|
Total
|
162,405
|
162,404.74
|
Pass
|
Fifth Level Check
Test Conducted
Group: Emerging Sales > Daniel Broderick > David Biwer > REBEL GROUP
Period - February
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
402
|
402
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Last Year
|
0
|
0
|
Pass
|
4
|
Total
|
402
|
402
|
Pass
|
Dynamic Group 3:
Test Conducted
Dynamic Grouping Parameter(3) and Group Name: Region > Sales Manager > Country > Sales Rep > Customer
Secondary Level Check
Test Conducted
Group: North America Sales
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
24,957,795
|
24,957,795.40
|
Pass
|
2
|
Open
|
26,647
|
26,646.76
|
Pass
|
3
|
Last Year
|
15,310,037
|
15,310,037.31
|
Pass
|
4
|
Total
|
24,984,442
|
24,984,442.16
|
Pass
|
Third Level Check
Test Conducted
Group:EMEA > Loris PinCerato
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
3,394
|
3,394.01
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Last Year
|
0
|
0
|
Pass
|
4
|
Total
|
3,394
|
3,394.01
|
Pass
|
Fourth Level Check
Test Conducted
Group: Emerging Sales > Yoo Kang > South Korea
Period - April
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
111,199
|
111,198.92
|
Pass
|
2
|
Open
|
26,640
|
26,639.79
|
Pass
|
3
|
Last Year
|
0
|
0
|
Pass
|
4
|
Total
|
137,839
|
137,838.71
|
Pass
|
Fifth Level Check
Test Conducted
Group: North America Sales > Al Derago > Hong Kong > House
Period - February
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
6,524,441
|
6,524,440.60
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Last Year
|
0
|
0
|
Pass
|
4
|
Total
|
6,524,441
|
6,524,440.60
|
Pass
|
Sixth Level Check
==
==
Test Conducted
Group: EMEA Sales > Thierry Tonnerieux > France > Stephane Dauger > GAIA
Period - May
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail
|
1
|
Shipped
|
3,096
|
3,096.13
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Last Year
|
0
|
0
|
Pass
|
4
|
Total
|
3,096
|
3,096.13
|
Pass
|
Euro Conversion Check
Normal USD Shipped Value of EMEA Sales for May Month: 4,404,275
Currency Conversion Rate of May for Euro : 0.76720
Group: EMEA Sales
SNo
|
Test Case
|
Value in CR
|
Value Expected
|
Pass/Fail
|
1
|
Shipped
|
3,378,959
|
3,378,959.78
|
Pass
|
Reference Document(Enhancement)
2013-05-24 - 5996.200 - Enhancement - Changes to SA170